| FaMultipleRecAckWork |
| Logical Entity Name | FaMultipleRecAckWork |
| Default Table Name | FaMultipleRecAckWork |
| Physical Only | NO |
| Definition | |
| Note |
| FaMultipleRecAckWork Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaMultipleRecAckWorkID |
int | NO | ||
| RecordType | char(2) | YES | ||
| AwardYear | char(7) | YES | ||
| BatchID | char(26) | YES | ||
| RegPellID | char(6) | YES | ||
| MRCode1 | char(1) | YES | ||
| MRCode2 | char(1) | YES | ||
| MRStudentID | char(11) | YES | ||
| MRPellID | char(6) | YES | ||
| SSN | char(9) | YES | ||
| NameCode | char(2) | YES | ||
| AttPellID | char(6) | YES | ||
| InstName | char(70) | YES | ||
| Addr1 | char(35) | YES | ||
| Addr2 | char(35) | YES | ||
| City | char(25) | YES | ||
| State | char(2) | YES | ||
| Zip | char(9) | YES | ||
| FAAName | char(30) | YES | ||
| FAAPhone | char(10) | YES | ||
| FAAFax | char(10) | YES | ||
| char(50) | YES | |||
| PellGrant | char(8) | YES | ||
| AwardAmount | char(8) | YES | ||
| TranNumb | char(2) | YES | ||
| EIC | char(5) | YES | ||
| EnrollDate | char(10) | YES | ||
| OrigCreateDate | char(10) | YES | ||
| TotalDisbAccept | char(8) | YES | ||
| LastActivityDate | char(10) | YES | ||
| NextExpDisbDate | char(10) | YES | ||
| EligUsed | char(7) | YES | ||
| EdFlags | char(10) | YES | ||
| DateAdded | datetime | YES | ||
| DateLstMod | datetime | YES | ||
| UserID | int | YES | ||
| StudentDOB | char(10) | YES | ||
| StudentFirstName | char(12) | YES | ||
| StudentLastName | char(16) | YES | ||
| StudentMI | char(1) | YES | ||
| CurrentSSN | char(9) | YES | ||
| ts | timestamp | NO | ||
| AddlEligibilityInd | bit | NO | ||
| LifetimeEligUsed | char(8) | NO | ||
| Post911DVDInd | bit | NO |
| FaMultipleRecAckWork Primary and Unique Keys |
| Key Name | Key Type | Keys |
| FaMultipleRecAckWork_FaMultipleRecAckWorkID_U_C_IDX | PrimaryKey | FaMultipleRecAckWorkID |
| FaMultipleRecAckWork Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaMultipleRecAckWork Check Constraints |
| Check Constraint Name | CheckConstraint |